Excel workbook with updated and PowerPoint templates populated with poverty and housing insecurity data by Catalyst California for the First 5 LA Office of Data for Action. This work is part of Catalyst California’s ongoing strategic partnership and technical support for First 5 LA departments.
The I&A team at First 5 LA asked Catalyst California for updated data on poverty among households with children under five in Los Angeles County. The data are by racial-ethnic group, Service Planning Area (SPA) and county for 2022 and 2023. For this data update, Catalyst California analyzed poverty at both the 100% FPL level and the 138% FPL level. Data is analyzed for both FPL levels for years 2022 and 2023. Estimates that are cut by race use 2022 and 2023 5-year estimates. Estimates at the SPA level and county level use 2022 and 2023 1-year estimates.
Catalyst California also created a PUMA to SPA crosswalk map to visualize which PUMAs across Los Angeles County fall within each of the five SPAs.The code for creating this crosswalk and the map visualization can be found further below on this page.
Data for households with children 0-5 in poverty is available by PUMA and the request is for that data by SPA. We created a PUMA-SPA crosswalk to facilitate calculating numbers and percentages of households with children 0-5 by SPA.
There are 71 PUMAs in LA County with blue borders with identification numbers between 03703 and 03782, with 037 being the LA County identifier. These numbers are on the initial labeling on the map hover.
There are 8 SPAs in LA County with black borders numbered one through eight below. You can see these labels by turning off/unchecking the PUMA layer. Note: SPA 7 has a cut out of SPA 8 in the Signal Hill area.
The crosswalk of PUMAs to SPAs we use to attribute household 0-5 poverty data are the colored areas, colored by SPA. The areas without colors are the smaller portions of PUMAs that overlap multiple SPAs. For example, the non-colored portion of PUMA 03709 (at the center of the map in La Canada Flintridge) is the portion of PUMA 03709 that falls in SPA 2. The vast majority of PUMA 03709 falls in SPA 3, so it is attributed to SPA 3 and not SPA 2. We don’t attribute fractions of PUMAs to SPAs because the additional the potential increase in accuracy is outweighed by a decrease in statistical stability.
Below is the code for visualizing the PUMAs to SPAs crosswalk:
Reading layer `Service_Planning_Areas__2022_' from data source
`W:\Project\RDA Team\First5LA\Ad-hoc Research\Laura ask poverty update\Shapes\Service_Planning_Areas__2022_.shp'
using driver `ESRI Shapefile'
Simple feature collection with 8 features and 8 fields
Geometry type: MULTIPOLYGON
Dimension: XY
Bounding box: xmin: 6275488 ymin: 1386069 xmax: 6668481 ymax: 2122085
Projected CRS: NAD83 / California zone 5 (ftUS)
| | | 0% | | | 1% | |= | 1% | |= | 2% | |== | 3% | |== | 4% | |=== | 4% | |=== | 5% | |=== | 6% | |==== | 6% | |==== | 7% | |===== | 8% | |===== | 9% | |====== | 9% | |====== | 10% | |====== | 11% | |======= | 11% | |======= | 12% | |======== | 13% | |======== | 14% | |========= | 15% | |========= | 16% | |========== | 16% | |========== | 17% | |=========== | 18% | |=========== | 19% | |============ | 19% | |============ | 20% | |============= | 21% | |============= | 22% | |============== | 23% | |============== | 24% | |=============== | 25% | |=============== | 26% | |================ | 26% | |================ | 27% | |================= | 28% | |================= | 29% | |================== | 30% | |=================== | 31% | |=================== | 32% | |==================== | 33% | |==================== | 34% | |===================== | 35% | |====================== | 36% | |====================== | 37% | |======================= | 38% | |======================= | 39% | |======================== | 40% | |========================= | 41% | |========================= | 42% | |========================== | 43% | |========================== | 44% | |=========================== | 45% | |============================ | 46% | |============================ | 47% | |============================= | 48% | |============================= | 49% | |============================== | 50% | |=============================== | 51% | |=============================== | 52% | |================================ | 53% | |================================ | 54% | |================================= | 55% | |================================== | 56% | |================================== | 57% | |=================================== | 58% | |=================================== | 59% | |==================================== | 60% | |===================================== | 61% | |===================================== | 62% | |====================================== | 63% | |====================================== | 64% | |======================================= | 65% | |======================================== | 66% | |======================================== | 67% | |========================================= | 68% | |========================================= | 69% | |========================================== | 70% | |=========================================== | 71% | |=========================================== | 72% | |============================================ | 73% | |============================================ | 74% | |============================================= | 75% | |============================================== | 76% | |============================================== | 77% | |=============================================== | 78% | |=============================================== | 79% | |================================================ | 80% | |================================================= | 81% | |================================================= | 82% | |================================================== | 83% | |================================================== | 84% | |=================================================== | 84% | |=================================================== | 85% | |==================================================== | 86% | |==================================================== | 87% | |===================================================== | 88% | |===================================================== | 89% | |====================================================== | 90% | |======================================================= | 91% | |======================================================= | 92% | |======================================================== | 93% | |======================================================== | 94% | |========================================================= | 94% | |========================================================= | 95% | |========================================================== | 96% | |========================================================== | 97% | |=========================================================== | 98% | |=========================================================== | 99% | |============================================================| 99% | |============================================================| 100%
| | | 0% | |= | 1% | |= | 2% | |== | 4% | |=== | 5% | |==== | 6% | |===== | 8% | |====== | 9% | |====== | 10% | |======= | 12% | |======== | 13% | |========= | 15% | |========== | 16% | |========== | 17% | |=========== | 19% | |============ | 20% | |============= | 21% | |============== | 23% | |============== | 24% | |=============== | 25% | |================ | 27% | |================= | 28% | |================== | 29% | |================== | 31% | |=================== | 32% | |==================== | 33% | |===================== | 35% | |====================== | 36% | |====================== | 37% | |======================= | 39% | |======================== | 40% | |========================= | 41% | |========================== | 43% | |========================== | 44% | |=========================== | 45% | |============================ | 47% | |============================= | 48% | |============================== | 49% | |============================== | 51% | |=============================== | 52% | |================================ | 53% | |================================= | 55% | |================================== | 56% | |================================== | 57% | |=================================== | 59% | |==================================== | 60% | |===================================== | 61% | |====================================== | 63% | |======================================= | 64% | |======================================= | 66% | |======================================== | 67% | |========================================= | 68% | |========================================= | 69% | |========================================== | 70% | |========================================== | 71% | |=========================================== | 71% | |=========================================== | 72% | |============================================ | 73% | |============================================ | 74% | |============================================= | 75% | |============================================== | 76% | |=============================================== | 78% | |=============================================== | 79% | |================================================ | 80% | |================================================= | 82% | |================================================== | 83% | |=================================================== | 84% | |=================================================== | 86% | |==================================================== | 87% | |===================================================== | 88% | |====================================================== | 90% | |======================================================= | 91% | |======================================================= | 92% | |======================================================== | 94% | |========================================================= | 95% | |========================================================== | 96% | |=========================================================== | 98% | |=========================================================== | 99% | |============================================================| 100%